/****** Object:  Stored Procedure dbo.asi_ProcessEngineTypeByKey    Script Date: 7/3/2003 4:58:04 PM ******/
CREATE   PROC [dbo].[asi_ProcessEngineTypeByKey]
    @typeKey uniqueidentifier
    AS
BEGIN
    SET ROWCOUNT 1
    SELECT    ProcessEngineType.ProcessEngineTypeKey,
            ProcessEngineType.Name,
            ProcessEngineType.Assembly,
            ProcessEngineType.QualifiedName,
            ProcessEngineType.HasTemplate,
            ProcessEngineType.HasDesigner

     FROM    ProcessEngineType
            
     WHERE    ProcessEngineType.ProcessEngineTypeKey = @typeKey
    SET ROWCOUNT 0
END

GO